<?php
$mysqldatabasecreate = '1';
require('index.php');
if(!empty($userfoundincheck)) {
mysql_query(
"CREATE TABLE bible_favorites(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
`favoriteverse` VARCHAR(20),
`user` VARCHAR(20),
`datetime` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) CHARACTER SET = utf8 COLLATE = utf8_general_ci;") or die(mysql_error());
 echo "Database Table bible_favorites Created<br>";
 mysql_query(
"CREATE TABLE bible_notes(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
`verse` VARCHAR(20),
`user` VARCHAR(20),
`datetime` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`note` TEXT) CHARACTER SET = utf8 COLLATE = utf8_general_ci;") or die(mysql_error());
 echo "Database Table bible_notes Created<br>";
mysql_query(
"CREATE TABLE bible_bookmarks(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
`bookmark` VARCHAR(20),
`user` VARCHAR(20),
`datetime` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) CHARACTER SET = utf8 COLLATE = utf8_general_ci;") or die(mysql_error());
 echo "Database Table bible_bookmarks Created<br>";
 mysql_close();
 } else { "You must login to create database tables<br>"; }
?>